-- 地块灌溉数据
SELECT C.*
, sfc.bulk_density, sfc.water_Holding_capacity, sfc.water_content 
, D1.VALUE irrigation_available
FROM [dbo].[Cropland] C
LEFT JOIN soil_field_capacity sfc ON C.soil_type=sfc.soil_type
LEFT JOIN Dict D1 ON D1.TYPE='irrigation_available' AND D1.NAME = C.irrigation_type
WHERE C.id=:id